create external table jms_ods.t_ass_sorting_equipment
(
  id                string  comment '主键'
  ,equipment_name    string  comment '设备名称'
  ,owned_venue_name  string  comment '所属场地名称'
  ,owned_venue_code  string  comment '所属场地编号'
  ,supplier_code     string  comment '供应商标识'
  ,supplier_name     string  comment '供应商名称'
  ,equipment_code    string  comment '设备编码 供应商标识+网点编号+序号'
  ,equipment_layer   string  comment '设备层数'
  ,infeed_area       string  comment '供件区'
  ,for_charter_num   string  comment '供包台数量'
  ,lattice_num       string  comment '格口数量'
  ,trolley_num       string  comment '小车数量'
  ,docking_time      string  comment '对接时间'
  ,create_time       string  comment '创建时间'
  ,update_time       string  comment '修改时间'
  ,ext_info          string  comment '扩展字段'
  ,ext_info1         string  comment '扩展字段'
  ,valid             string  comment '有效标志（1：有效，2：无效，）'
  ,owned_venue_type  string  comment '场地类型:335:中心 :336 网点'
  ,agency_area_name  string  comment '代理区名称'
  ,agency_area_code  string  comment '代理商编号'
  ,franchisee_name   string  comment'加盟商名称'
  ,franchisee_code   string  comment'加盟商编号'
  ,create_user       string  comment '创建用户'
  ,update_user       string  comment '修改用户'
  ,equipment_type    string  comment '设备类型'
)
)comment  '分拣机器械信息表'
partitioned by (
  `dt` string comment '创建日期 (yyyy-mm-dd)')
stored as parquet
location
  'hdfs://yl-bg-hdp/dw/hive/jms_ods.db/external/t_ass_sorting_equipment';
